﻿
/****** Object:  User Defined Function dbo.GetSintetic    Script Date: 2/4/2006 10:03:35 PM ******/
CREATE FUNCTION GetSintetic (@Cont TipCont)  
RETURNS TipCont  AS  
BEGIN 
DECLARE @posPunct int
SET @posPunct = CHARINDEX('.',@Cont)
DECLARE @ret TipCont
SET @ret = @Cont
IF @posPunct <> 0
	BEGIN
		SET @ret = SUBSTRING(@Cont	,1,@posPunct-1)
	END
return @ret	
END